Aleno Token Report PoC¶

This POC is done on ERC20 contracts where we analyse the token holders. This same analysis can be done on any contract type to analyze the users and can be automated¶

Token general information¶

Token name :  agEUR
Token symbol :  agEUR
Token ID 52541
Statistics computed 2022-10-21 18:14:00
 Price 0.9844077
total dex volume 1 B agEUR
total dex usd volume 1 B$
agEUR is swapped in 8 pools on 3 different exchanges
address protocol_id swap_count usd_volume
0x8db1b906d47dfc1d84a87fc49bd0522e285b98b9 Uniswap v3 21272 235826735.000000
0x735a26a57a0a0069dfabd41595a970faf5e1ee8b Uniswap v3 21115 516202305.000000
0x7ed3f364668cd2b9449a8660974a26a092c64849 Uniswap v3 6056 435974000.000000
0x1f4c763bde1d4832b3ea0640e66da00b98831355 SushiSwap 5833 58649600.000000
0x9496d107a4b90c7d18c703e8685167f90ac273b0 Uniswap v3 4538 115947008.000000
0x8ce5796ef6b0c5918025bcf4f9ca908201b030b3 Uniswap v3 3196 111646155.000000
0x3aaa7f4c1f6bce9b01462905776655386b74a29a Uniswap v2 616 790957.400000
0xf89ce5ed65737da8440411544b0499c9fad323b2 Uniswap v2 580 7014162.250000

Price evolution¶

Accounts analysis¶

2577 have been exposed to agEUR through decentralized exchanges on ethereum
1238 accounts have bought agEUR on decentralized exchanges and have a non null balance
585 are currently holding agEUR

At the moment we can analyse 3 types of players:

  • All the addresses that interacted with the token through DEXES
  • All the addresses that bought some tokens though DEXES without selling them
  • All the "True" token holders

Holdings distribution without extreme values¶

151 holders have more than 100 agEUR

Some dapps offer a tiering systems for they users that enables different perks. The following analysis could be split into the analysis of these different tiers to display major differencies between those groups.

Holders Description¶

Comparer avec les gens qui swap le token utiliser les balances etherscan Regarder l'activité de swapping labeliser non swapper address labeliser passif holders plutot que simple holder

There were 281 active accounts last month

Labeling definition can be improved. What other labels should we add ?

We could add a graph showing the distribution of the age of the users

Some accounts are not labeled since they don't apear in our database. Should we add them ?

Some addresses might have transferred their tokens to other addresses or other chains so holders are not 100% exact. Tracking those transfers could be added for a slight improvement. Current analysis is quite representative when empirically verifying results

We could also cludter the related accounts that have done some inner transfers

This analysis could be handled on all the addresses that interacted with the tokens and not only the current holders

From here bots are removed from the analysis¶

Removing 1.35% bot accounts from the analysis

Should We add the distribution only for users ? Or most precisely active users ?

Show recent holders interaction (4 weeks old)¶

Recent asset swapped¶

Notable recent tokens swaped by agEUR holders removing ['WETH', 'USDC', 'USDT', 'DAI', 'WBTC', 'UNI', 'SUSHI', 'MATIC', 'SHIB', 'HEX']
address name symbol swap_count total_dollar_volume
0x1a7e4e63778b4f12a199c062f3efdd288afcbce8 agEUR agEUR 584 18585993.137293
0x1abaea1f7c830bd89acc67ec4af516284b1bc33c Euro Coin EUROC 185 4185397.337500
0x853d955acef822db058eb8505911ed77f175b99e Frax FRAX 143 2668980.364335
0x956f47f50a910163d8bf957cf5846d573e7f87ca Fei USD FEI 34 488109.145001
0x3432b6a60d23ca0dfca7761b7ab56459d9c964d0 Frax Share FXS 113 436328.250813
0x03ab458634910aad20ef5f1c8ee96f1d6ac54919 Rai Reflex Index RAI 20 303966.701620
0x4fabb145d64652a948d72533023f6e7a623c7c53 Binance USD BUSD 26 292900.925140
0x31429d1856ad1377a8a0079410b297e1a9e214c2 ANGLE ANGLE 75 198200.026629
0xd9fcd98c322942075a5c3860693e9f4f03aae07b Euler EUL 56 187387.374429
0x954b890704693af242613edef1b603825afcd708 Cardstack CARD 49 152941.413495
0x0f2d719407fdbeff09d87557abb7232601fd9f29 Synapse SYN 9 138539.716324
0x111111111117dc0aa78b770fa6a738034120c302 1INCH Token 1INCH 7 138006.194880
0xd533a949740bb3306d119cc777fa900ba034cd52 Curve DAO Token CRV 76 126394.211331
0x68037790a0229e9ce6eaa8a99ea92964106c4703 PAR Stablecoin PAR 6 126004.314290
0x41f7b8b9b897276b7aae926a9016935280b44e97 USD Coin USDC 4 113594.320000
0xae78736cd615f374d3085123a210448e74fc6393 Rocket Pool ETH rETH 12 107629.745815
0xc5bddf9843308380375a611c18b50fb9341f502a veCRV-DAO yVault yveCRV-DAO 29 94517.711450
0x5f98805a4e8be255a32880fdec7f6728c6568ba0 LUSD Stablecoin LUSD 22 84753.425205
0x7659ce147d0e714454073a5dd7003544234b6aa0 XCAD Token XCAD 27 76471.796280
0x0c10bf8fcb7bf5412187a595ab97a3609160b5c6 Decentralized USD USDD 3 70113.784937

Do we need to analyze recent swaps more in depth ?

Recent contract interaction by removing ERC20 Tokens¶

to_address transaction_count unique_account_count label
0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45 344 78 Uniswap V3 Router
0x1111111254fb6c44bac0bed2854e76f90643097d 812 63 1inch v4 Router
0xf403c135812408bfbe8713b5a23a04b3d48aae31 111 47 Convex Finance: Booster
0xdef171fe48cf0115b1d80b88dc8eab59176fee57 476 45 Paraswap Augustus v5
0xdd49a93fdcae579ae50b4b9923325e9e335ec82b 64 35 Convex: Claim Zap
0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f 126 35 SushiSwap Router
0x633120100e108f03ace79d6c78aac9a56db1be0f 45 30 Stake DAO Claim Rewards
0xdef1c0ded9bec7f1a1670819833240f027b25eff 74 26 0x: Exchange Proxy
0x00000000006c3852cbef3e08e8df289169ede581 143 25 Seaport 1.1
0x5de4ef4879f4fe3bbadf2227d2ac5d0e2d76c895 46 20 nan
0x72a19342e8f1838460ebfccef09f6585e32db86e 46 20 Vote Locked Convex Token (vlCVX)
0x03e34b085c52985f6a5d27243f20c84bddc01db4 30 20 nan
0x569f5b842b5006ec17be02b8b94510ba8e79fbca 36 19 Convex Booster
0xba3436fd341f2c8a928452db3c5a3670d1d5cc73 49 19 Curve.fi Factory Plain Pool: agEUR/EUROC
0xa0c68c638235ee32657e8f720a23cec1bfc77c77 43 19 Polygon Matic Bridge
0xa79828df1850e8a3a3064576f380d90aecdd3359 33 19 Curve Finance: 3Pool Deposit Zap
0xba12222222228d8ba445958a75a0704d566bf2c8 86 18 Balancer Vault
0xbb755240596530be0c1de5dfd77ec6398471561d 35 17 Angle Protocol Router
0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f 20 16 Arbitrum: Delayed Inbox
0xb9446c4ef5ebe66268da6700d26f96273de3d571 47 16 Curve.fi Factory Plain Pool: 3EURpool
0xe7a3b38c39f97e977723bd1239c3470702568e7b 45 15 Curve.fi Factory Plain Pool: Euro Pool
0x59828fdf7ee634aaad3f58b19fdba3b03e2d9d80 127 15 Euler Proxy
0x378ba9b73309be80bf4c2c027aad799766a7ed5a 27 15 Votium: Multi Merkle Stash
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 82 15 Aave: Lending Pool V2
0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 20 15 Curve.fi: DAI/USDC/USDT Pool
0x29f3dd38db24d3935cf1bf841e6b2b461a3e5d92 23 14 Stake DAO: Angle fee distributor
0x08780fb7e580e492c1935bee4fa5920b94aa95da 33 14 nan
0x5a93d504604fb57e15b0d73733ddc86301dde2f1 37 14 Angle Proxy
0x4a9b7edd67f58654a2c33b587f98c5709ac7d482 27 14 nan

All time User interaction¶

Most swapped assets all time by token holders¶

Notable tokens held by agEUR holders removing ['WETH', 'USDC', 'USDT', 'DAI', 'WBTC', 'UNI', 'SUSHI', 'MATIC', 'SHIB', 'HEX']
unique_account_count name symbol price usd_exposure address
317 agEUR agEUR 0.984408 66488871.076645 0x1a7e4e63778b4f12a199c062f3efdd288afcbce8
200 ANGLE ANGLE 0.025885 1142765.697903 0x31429d1856ad1377a8a0079410b297e1a9e214c2
190 Curve DAO Token CRV 0.893621 4597178.267203 0xd533a949740bb3306d119cc777fa900ba034cd52
187 Frax FRAX 0.999393 164182124.280443 0x853d955acef822db058eb8505911ed77f175b99e
159 Convex Token CVX 5.036283 14601848.360072 0x4e3fbd56cd56c3e72c1403e103b45db9da5b9d2b
113 Frax Share FXS 6.336399 30163655.473386 0x3432b6a60d23ca0dfca7761b7ab56459d9c964d0
105 Fei USD FEI 1.000000 54924257.323469 0x956f47f50a910163d8bf957cf5846d573e7f87ca
103 Stake DAO Token SDT 0.404658 530117.276313 0x73968b9a57c6e53d41345fd57a6e6ae27d6cdb2f
85 Spell Token SPELL 0.000836 5064296.364036 0x090185f2135308bad17527004364ebcc2d37e5f6
84 Olympus OHM 54.236073 4004955.409689 0x383518188c0c6d7730d91b2c03a03c837814a899
83 Aave Token AAVE 83.086360 949376.900838 0x7fc66500c84a76ad7e9c93437bfc5ac33e2ddae9
79 Synthetix Network Token SNX 2.190435 979944.002626 0xc011a73ee8576fb46f5e1c5751ca3b9fe0af2a6f
72 1INCH Token 1INCH 0.560472 396758.754112 0x111111111117dc0aa78b770fa6a738034120c302
72 Compound COMP 49.589275 306921.160129 0xc00e94cb662c3520282e6f5717214004a7f26888
69 Badger BADGER 3.170393 425144.966957 0x3472a5a71965499acd81997a54bba8d852c6e53d
65 LUSD Stablecoin LUSD 1.028224 12416525.613285 0x5f98805a4e8be255a32880fdec7f6728c6568ba0
63 LooksRare Token LOOKS 0.218606 1294962.132990 0xf4d2888d29d722226fafa5d9b24f9164c092421e
63 STASIS EURS Token EURS 1.022560 19984773.276594 0xdb25f211ab05b1c97d595516f45794528a807ad8
63 Alchemix ALCX 19.334600 1013323.980545 0xdbdb4d16eda451d0503b854cf79d55697f90c8df
63 Convex CRV cvxCRV 0.832375 928009.793653 0x62b9c7356a2dc64a1969e19c23e4f579f9810aa7
  • This Could be improved by labeling tokens category such as (DeFi, P2E, Stables etc ...)
  • Same table can be done with all accounts that interacted with the token, not only the current holders

Most used contracts by holders by removing ERC20 Tokens¶

to_address transaction_count unique_account_count label
0x68b3465833fb72a70ecdf485e0e4c7bd8665fc45 4778 281 Uniswap V3 Router
0xd9e1ce17f2641f24ae83637ab66a2cca9c378b9f 10945 277 SushiSwap Router
0xe592427a0aece92de3edee1f18e0157c05861564 4463 239 Uniswap V3 Router
0x1111111254fb6c44bac0bed2854e76f90643097d 25680 220 1inch v4 Router
0xa0c68c638235ee32657e8f720a23cec1bfc77c77 2938 208 Polygon Matic Bridge
0xf403c135812408bfbe8713b5a23a04b3d48aae31 1637 196 Convex Finance: Booster
0x5addc89785d75c86ab939e9e15bfbbb7fc086a87 572 181 nan
0x4dbd4fc535ac27206064b68ffcf827b0a60bab3f 444 173 Arbitrum: Delayed Inbox
0xdef1c0ded9bec7f1a1670819833240f027b25eff 7483 169 0x: Exchange Proxy
0xbebc44782c7db0a1a60cb6fe97d0b483032ff1c7 855 159 Curve.fi: DAI/USDC/USDT Pool
0xa79828df1850e8a3a3064576f380d90aecdd3359 1165 153 Curve Finance: 3Pool Deposit Zap
0xdef171fe48cf0115b1d80b88dc8eab59176fee57 2796 150 Paraswap Augustus v5
0x11111112542d85b3ef69ae05771c2dccff4faa26 5836 141 1inch v3
0xba12222222228d8ba445958a75a0704d566bf2c8 1503 140 Balancer Vault
0x7d2768de32b0b80b7a3454c06bdac94a69ddc7a9 3051 133 Aave: Lending Pool V2
0xa5409ec958c83c3f309868babaca7c86dcb077c1 134 127 Opensea Registry
0x881d40237659c251811cec9c364ef91dc08d300c 900 126 Metamask Router
0x7be8076f4ea4a4ad08075c2508e481d6c946d12b 3522 126 Opensea Wyvern exchange V1
0xb9446c4ef5ebe66268da6700d26f96273de3d571 551 121 Curve.fi Factory Plain Pool: 3EURpool
0x99c9fc46f92e8a1c0dec1b1747d010903e884be1 271 118 Optimism Gateway
0xd061d61a4d941c39e5453435b6345dc261c2fce0 1361 113 nan
0x469788fe6e9e9681c6ebf3bf78e7fd26fc015446 283 108 Snapshot: Delegation
0x4678f0a6958e4d2bc4f1baf7bc52e8f3564f3fe4 109 106 Maker: Proxy Registry
0xd632f22692fac7611d2aa1c0d552930d43caed3b 409 101 nan
0xdd49a93fdcae579ae50b4b9923325e9e335ec82b 560 100 Convex: Claim Zap
0x283af0b28c62c092c9727f1ee09c02ca627eb7f5 710 100 ENS: ETH Registrar Controller
0x92cf9e5e4d1dfbf7da0d2bb3e884a68416a65070 422 96 nan
0xabea9132b05a70803a4e85094fd0e1800777fbef 170 94 zkSync

Open questions and ideas¶

New Holders/Users analysis and notifications

Should we show holdings evolution through time ? Or interactions through time ? Daily contract Usage

Stickyness and churn analysis ? Analyse how many addresses keep using the contract or churned ?

Add a User leader board ?

Should we perform the same analysis on only active addresses ? Or historical users ?

Should we try deducting timezones based on activity timestamp ?

For general contracts should we add a google analytics Integration ?

What other labels can we add ?

Should we tag tokens and contracts in different categories such as DEFI, P2E ... ?

What other data do you want to measure on your users/holders ?

Are True User balance in ERC20 and ERC721 Usefull ?

Should We add a community tool ? Could be used to find Addresses that belong to the same owner or that have same onchain behaviour ?

Registered ENS analysis, Scrap data about all addresses that have a registered ENS.